8  Consider the relation r,  shown in following,        Building  room_number    time_slot_id  course_id  sec_id       Garfield     359           A            BIO-101  1       Garfield     359          ...

profilexpssan_athenc_
Home>Homework Answsers>Computer Science homework help

8  Consider the relation r,  shown in following, 

      Building  room_number    time_slot_id  course_id  sec_id

      Garfield     359           A            BIO-101  1

      Garfield     359           B            BIO-101  2

      Saucon      651          A            CS-101   2

      Saucon      350          C             CS-319   1

      Painer       705          D            MU-199   1

      Painer       403          D            FIN-201   1

give the result of the following query:

   Select building, room_number, time_slot_id, count(*)  from r

   Group by rollup(building, room_number, time_slot_id)

    • 11 years ago
    • 999999.99
    Report issue
    Answer(0)
    Bids(0)